select Address, ClientName, DeviceType, 
substring(LastConnected,1,4)+'/'+substring(LastConnected,5,2)+'/'+substring(LastConnected,7,2)  as LastConnectedF, LastConnected 
, WhenLoaded
from [dclink42pd].[dbo].[dsicfgTranCollectors] 
Where Address like '172.30.%'      --Torrance
order by Address

--where LastConnected < 20091230000000
--Where Address in ('172.30.5.109','172.30.5.120','172.30.5.122','172.30.5.141')

--Where Address like '172.18.%'      --Houston
--Where Address like '172.30.%'      --Torrance
--Where Address like '192.168.201%'  --Northlake
--Where Address like '192.168.202%'  --Moonachie
--Where Address like '192.168.203%'  --Oklahama City
--Where Address like '192.168.204%'  --Fridley
--Where Address like '192.168.252%'  --Brewmatic
